Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 932 |
| Missing cells | 4 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 94.8 KiB |
| Average record size in memory | 104.1 B |
Variable types
| Text | 2 |
|---|---|
| Categorical | 3 |
| Numeric | 7 |
| DateTime | 1 |
ItemType SalesChannel is highly overall correlated with Total and 1 other fields | High correlation |
Revenue is highly overall correlated with Total and 4 other fields | High correlation |
Total is highly overall correlated with ItemType SalesChannel and 4 other fields | High correlation |
TotalCost is highly overall correlated with Revenue and 4 other fields | High correlation |
TotalProfit is highly overall correlated with Revenue and 4 other fields | High correlation |
UnitCost is highly overall correlated with ItemType SalesChannel and 4 other fields | High correlation |
UnitPrice is highly overall correlated with Revenue and 2 other fields | High correlation |
UnitsSold has unique values | Unique |
Reproduction
| Analysis started | 2024-08-12 17:10:28.824616 |
|---|---|
| Analysis finished | 2024-08-12 17:10:43.447645 |
| Duration | 14.62 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
Region
Text
| Distinct | 112 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 KiB |
Length
| Max length | 51 |
|---|---|
| Median length | 48 |
| Mean length | 17.56867 |
| Min length | 4 |
Characters and Unicode
| Total characters | 16374 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | 4.1% |
Sample
| 1st row | Middle East and North Africa |
|---|---|
| 2nd row | North America |
| 3rd row | Middle East and North Africa |
| 4th row | Asia |
| 5th row | Sub-Saharan Africa |
| Value | Count | Frequency (%) |
| africa | 374 | |
| and | 294 | 12.6% |
| north | 135 | 5.8% |
| east | 131 | 5.6% |
| america | 107 | 4.6% |
| caribbean | 92 | 3.9% |
| the | 92 | 3.9% |
| central | 92 | 3.9% |
| oceania | 71 | 3.0% |
| 0europe | 30 | 1.3% |
| Other values (79) | 912 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2332 | |
| 1914 | 11.7% | |
| r | 1387 | 8.5% |
| i | 988 | 6.0% |
| e | 858 | 5.2% |
| n | 806 | 4.9% |
| A | 682 | 4.2% |
| u | 564 | 3.4% |
| c | 563 | 3.4% |
| d | 558 | 3.4% |
| Other values (31) | 5722 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16374 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2332 | |
| 1914 | 11.7% | |
| r | 1387 | 8.5% |
| i | 988 | 6.0% |
| e | 858 | 5.2% |
| n | 806 | 4.9% |
| A | 682 | 4.2% |
| u | 564 | 3.4% |
| c | 563 | 3.4% |
| d | 558 | 3.4% |
| Other values (31) | 5722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16374 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2332 | |
| 1914 | 11.7% | |
| r | 1387 | 8.5% |
| i | 988 | 6.0% |
| e | 858 | 5.2% |
| n | 806 | 4.9% |
| A | 682 | 4.2% |
| u | 564 | 3.4% |
| c | 563 | 3.4% |
| d | 558 | 3.4% |
| Other values (31) | 5722 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16374 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2332 | |
| 1914 | 11.7% | |
| r | 1387 | 8.5% |
| i | 988 | 6.0% |
| e | 858 | 5.2% |
| n | 806 | 4.9% |
| A | 682 | 4.2% |
| u | 564 | 3.4% |
| c | 563 | 3.4% |
| d | 558 | 3.4% |
| Other values (31) | 5722 |
Country
Text
| Distinct | 190 |
|---|---|
| Distinct (%) | 20.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 KiB |
Length
| Max length | 33 |
|---|---|
| Median length | 27 |
| Mean length | 8.5321888 |
| Min length | 4 |
Characters and Unicode
| Total characters | 7952 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | Libya |
|---|---|
| 2nd row | Canada |
| 3rd row | Libya |
| 4th row | Japan |
| 5th row | Chad |
| Value | Count | Frequency (%) |
| republic | 31 | 2.6% |
| and | 23 | 1.9% |
| the | 22 | 1.8% |
| of | 19 | 1.6% |
| south | 16 | 1.3% |
| sudan | 15 | 1.3% |
| islands | 14 | 1.2% |
| saint | 12 | 1.0% |
| guinea | 11 | 0.9% |
| congo | 11 | 0.9% |
| Other values (207) | 1025 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1206 | |
| i | 685 | 8.6% |
| n | 623 | 7.8% |
| e | 532 | 6.7% |
| o | 413 | 5.2% |
| r | 403 | 5.1% |
| l | 316 | 4.0% |
| u | 306 | 3.8% |
| t | 299 | 3.8% |
| 270 | 3.4% | |
| Other values (43) | 2899 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7952 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1206 | |
| i | 685 | 8.6% |
| n | 623 | 7.8% |
| e | 532 | 6.7% |
| o | 413 | 5.2% |
| r | 403 | 5.1% |
| l | 316 | 4.0% |
| u | 306 | 3.8% |
| t | 299 | 3.8% |
| 270 | 3.4% | |
| Other values (43) | 2899 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7952 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1206 | |
| i | 685 | 8.6% |
| n | 623 | 7.8% |
| e | 532 | 6.7% |
| o | 413 | 5.2% |
| r | 403 | 5.1% |
| l | 316 | 4.0% |
| u | 306 | 3.8% |
| t | 299 | 3.8% |
| 270 | 3.4% | |
| Other values (43) | 2899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7952 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1206 | |
| i | 685 | 8.6% |
| n | 623 | 7.8% |
| e | 532 | 6.7% |
| o | 413 | 5.2% |
| r | 403 | 5.1% |
| l | 316 | 4.0% |
| u | 306 | 3.8% |
| t | 299 | 3.8% |
| 270 | 3.4% | |
| Other values (43) | 2899 |
ItemType SalesChannel
Categorical
HIGH CORRELATION 
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 KiB |
| Beverages | |
|---|---|
| Vegetables | |
| Office Supplies | |
| Personal Care | |
| Baby Food | |
| Other values (7) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 8.7854077 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8188 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cosmetics |
|---|---|
| 2nd row | Vegetables |
| 3rd row | Baby Food |
| 4th row | Cereal |
| 5th row | Fruits |
Common Values
| Value | Count | Frequency (%) |
| Beverages | 97 | |
| Vegetables | 94 | |
| Office Supplies | 84 | |
| Personal Care | 83 | |
| Baby Food | 79 | |
| Snacks | 74 | |
| Household | 73 | |
| Clothes | 71 | |
| Meat | 71 | |
| Cereal | 70 | |
| Other values (2) | 136 |
Length
| Value | Count | Frequency (%) |
| beverages | 97 | 8.2% |
| vegetables | 94 | 8.0% |
| office | 84 | 7.1% |
| supplies | 84 | 7.1% |
| personal | 83 | 7.0% |
| care | 83 | 7.0% |
| baby | 79 | 6.7% |
| food | 79 | 6.7% |
| snacks | 74 | 6.3% |
| household | 73 | 6.2% |
| Other values (5) | 348 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1331 | |
| s | 781 | 9.5% |
| a | 651 | 8.0% |
| o | 527 | 6.4% |
| l | 475 | 5.8% |
| r | 400 | 4.9% |
| t | 372 | 4.5% |
| i | 304 | 3.7% |
| C | 293 | 3.6% |
| 246 | 3.0% | |
| Other values (21) | 2808 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8188 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1331 | |
| s | 781 | 9.5% |
| a | 651 | 8.0% |
| o | 527 | 6.4% |
| l | 475 | 5.8% |
| r | 400 | 4.9% |
| t | 372 | 4.5% |
| i | 304 | 3.7% |
| C | 293 | 3.6% |
| 246 | 3.0% | |
| Other values (21) | 2808 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8188 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1331 | |
| s | 781 | 9.5% |
| a | 651 | 8.0% |
| o | 527 | 6.4% |
| l | 475 | 5.8% |
| r | 400 | 4.9% |
| t | 372 | 4.5% |
| i | 304 | 3.7% |
| C | 293 | 3.6% |
| 246 | 3.0% | |
| Other values (21) | 2808 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8188 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1331 | |
| s | 781 | 9.5% |
| a | 651 | 8.0% |
| o | 527 | 6.4% |
| l | 475 | 5.8% |
| r | 400 | 4.9% |
| t | 372 | 4.5% |
| i | 304 | 3.7% |
| C | 293 | 3.6% |
| 246 | 3.0% | |
| Other values (21) | 2808 |
OrderPriority
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 KiB |
| Offline | |
|---|---|
| Online |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.5182403 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6075 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Offline |
|---|---|
| 2nd row | Online |
| 3rd row | Offline |
| 4th row | Offline |
| 5th row | Offline |
Common Values
| Value | Count | Frequency (%) |
| Offline | 483 | |
| Online | 449 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| offline | 483 | |
| online | 449 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 1381 | |
| f | 966 | |
| O | 932 | |
| l | 932 | |
| i | 932 | |
| e | 932 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6075 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 1381 | |
| f | 966 | |
| O | 932 | |
| l | 932 | |
| i | 932 | |
| e | 932 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6075 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 1381 | |
| f | 966 | |
| O | 932 | |
| l | 932 | |
| i | 932 | |
| e | 932 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6075 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 1381 | |
| f | 966 | |
| O | 932 | |
| l | 932 | |
| i | 932 | |
| e | 932 |
OrderID
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.4 KiB |
| L | |
|---|---|
| C | |
| M | |
| H |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 932 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | C |
| 4th row | C |
| 5th row | H |
Common Values
| Value | Count | Frequency (%) |
| L | 249 | |
| C | 247 | |
| M | 229 | |
| H | 207 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| l | 249 | |
| c | 247 | |
| m | 229 | |
| h | 207 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 249 | |
| C | 247 | |
| M | 229 | |
| H | 207 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 932 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 249 | |
| C | 247 | |
| M | 229 | |
| H | 207 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 932 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 249 | |
| C | 247 | |
| M | 229 | |
| H | 207 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 932 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 249 | |
| C | 247 | |
| M | 229 | |
| H | 207 |
UnitsSold
Real number (ℝ)
UNIQUE 
| Distinct | 932 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4880586 × 108 |
| Minimum | 1.0292801 × 108 |
|---|---|
| Maximum | 9.9552983 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 1.0292801 × 108 |
|---|---|
| 5-th percentile | 1.4669453 × 108 |
| Q1 | 3.2736753 × 108 |
| median | 5.5410002 × 108 |
| Q3 | 7.6879841 × 108 |
| 95-th percentile | 9.4942607 × 108 |
| Maximum | 9.9552983 × 108 |
| Range | 8.9260182 × 108 |
| Interquartile range (IQR) | 4.4143088 × 108 |
Descriptive statistics
| Standard deviation | 2.5620493 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.46684074 |
| Kurtosis | -1.1827043 |
| Mean | 5.4880586 × 108 |
| Median Absolute Deviation (MAD) | 2.2089751 × 108 |
| Skewness | -0.022968805 |
| Sum | 5.1148706 × 1011 |
| Variance | 6.5640968 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 686800706 | 1 | 0.1% |
| 410231912 | 1 | 0.1% |
| 798784863 | 1 | 0.1% |
| 985092818 | 1 | 0.1% |
| 325412309 | 1 | 0.1% |
| 447917163 | 1 | 0.1% |
| 903740775 | 1 | 0.1% |
| 794969689 | 1 | 0.1% |
| 584204280 | 1 | 0.1% |
| 901180875 | 1 | 0.1% |
| Other values (922) | 922 |
| Value | Count | Frequency (%) |
| 102928006 | 1 | |
| 103617227 | 1 | |
| 104845464 | 1 | |
| 105117976 | 1 | |
| 105390059 | 1 | |
| 105558288 | 1 | |
| 105966842 | 1 | |
| 106578814 | 1 | |
| 106753051 | 1 | |
| 107005393 | 1 |
| Value | Count | Frequency (%) |
| 995529830 | 1 | |
| 994566810 | 1 | |
| 991644704 | 1 | |
| 990708720 | 1 | |
| 989928519 | 1 | |
| 989119565 | 1 | |
| 987714517 | 1 | |
| 986442506 | 1 | |
| 985665738 | 1 | |
| 985092818 | 1 |
UnitPrice
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 896 |
|---|---|
| Distinct (%) | 96.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5055.0558 |
| Minimum | 13 |
|---|---|
| Maximum | 9998 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 13 |
|---|---|
| 5-th percentile | 445.4 |
| Q1 | 2420.25 |
| median | 5202.5 |
| Q3 | 7587.25 |
| 95-th percentile | 9529.8 |
| Maximum | 9998 |
| Range | 9985 |
| Interquartile range (IQR) | 5167 |
Descriptive statistics
| Standard deviation | 2917.1905 |
|---|---|
| Coefficient of variation (CV) | 0.57708373 |
| Kurtosis | -1.2341792 |
| Mean | 5055.0558 |
| Median Absolute Deviation (MAD) | 2568 |
| Skewness | -0.053698272 |
| Sum | 4711312 |
| Variance | 8510000.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6283 | 3 | 0.3% |
| 8128 | 2 | 0.2% |
| 8775 | 2 | 0.2% |
| 7913 | 2 | 0.2% |
| 1578 | 2 | 0.2% |
| 2352 | 2 | 0.2% |
| 1547 | 2 | 0.2% |
| 9669 | 2 | 0.2% |
| 4247 | 2 | 0.2% |
| 822 | 2 | 0.2% |
| Other values (886) | 911 |
| Value | Count | Frequency (%) |
| 13 | 1 | |
| 25 | 1 | |
| 33 | 1 | |
| 61 | 1 | |
| 64 | 1 | |
| 70 | 1 | |
| 80 | 1 | |
| 89 | 1 | |
| 103 | 1 | |
| 114 | 1 |
| Value | Count | Frequency (%) |
| 9998 | 1 | |
| 9980 | 1 | |
| 9958 | 1 | |
| 9951 | 1 | |
| 9950 | 1 | |
| 9942 | 1 | |
| 9930 | 1 | |
| 9929 | 1 | |
| 9928 | 1 | |
| 9924 | 1 |
UnitCost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 261.49705 |
| Minimum | 9.33 |
|---|---|
| Maximum | 668.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 9.33 |
|---|---|
| 5-th percentile | 9.33 |
| Q1 | 81.73 |
| median | 154.06 |
| Q3 | 421.89 |
| 95-th percentile | 668.27 |
| Maximum | 668.27 |
| Range | 658.94 |
| Interquartile range (IQR) | 340.16 |
Descriptive statistics
| Standard deviation | 217.41799 |
|---|---|
| Coefficient of variation (CV) | 0.83143573 |
| Kurtosis | -0.74942399 |
| Mean | 261.49705 |
| Median Absolute Deviation (MAD) | 101.22 |
| Skewness | 0.79283801 |
| Sum | 243715.25 |
| Variance | 47270.582 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 47.45 | 97 | |
| 154.06 | 94 | |
| 651.21 | 84 | |
| 81.73 | 83 | |
| 255.28 | 79 | |
| 152.58 | 74 | |
| 668.27 | 73 | |
| 109.28 | 71 | |
| 421.89 | 71 | |
| 205.7 | 70 | |
| Other values (2) | 136 |
| Value | Count | Frequency (%) |
| 9.33 | 67 | |
| 47.45 | 97 | |
| 81.73 | 83 | |
| 109.28 | 71 | |
| 152.58 | 74 | |
| 154.06 | 94 | |
| 205.7 | 70 | |
| 255.28 | 79 | |
| 421.89 | 71 | |
| 437.2 | 69 |
| Value | Count | Frequency (%) |
| 668.27 | 73 | |
| 651.21 | 84 | |
| 437.2 | 69 | |
| 421.89 | 71 | |
| 255.28 | 79 | |
| 205.7 | 70 | |
| 154.06 | 94 | |
| 152.58 | 74 | |
| 109.28 | 71 | |
| 81.73 | 83 |
Total
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 184.75343 |
| Minimum | 6.92 |
|---|---|
| Maximum | 524.96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 6.92 |
|---|---|
| 5-th percentile | 6.92 |
| Q1 | 35.84 |
| median | 97.44 |
| Q3 | 263.33 |
| 95-th percentile | 524.96 |
| Maximum | 524.96 |
| Range | 518.04 |
| Interquartile range (IQR) | 227.49 |
Descriptive statistics
| Standard deviation | 176.20627 |
|---|---|
| Coefficient of variation (CV) | 0.95373747 |
| Kurtosis | -0.61295248 |
| Mean | 184.75343 |
| Median Absolute Deviation (MAD) | 61.98 |
| Skewness | 0.94731478 |
| Sum | 172190.2 |
| Variance | 31048.651 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31.79 | 97 | |
| 90.93 | 94 | |
| 524.96 | 84 | |
| 56.67 | 83 | |
| 159.42 | 79 | |
| 97.44 | 74 | |
| 502.54 | 73 | |
| 35.84 | 71 | |
| 364.69 | 71 | |
| 117.11 | 70 | |
| Other values (2) | 136 |
| Value | Count | Frequency (%) |
| 6.92 | 67 | |
| 31.79 | 97 | |
| 35.84 | 71 | |
| 56.67 | 83 | |
| 90.93 | 94 | |
| 97.44 | 74 | |
| 117.11 | 70 | |
| 159.42 | 79 | |
| 263.33 | 69 | |
| 364.69 | 71 |
| Value | Count | Frequency (%) |
| 524.96 | 84 | |
| 502.54 | 73 | |
| 364.69 | 71 | |
| 263.33 | 69 | |
| 159.42 | 79 | |
| 117.11 | 70 | |
| 97.44 | 74 | |
| 90.93 | 94 | |
| 56.67 | 83 | |
| 35.84 | 71 |
Revenue
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 931 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1326361.3 |
| Minimum | 2043.25 |
|---|---|
| Maximum | 6617209.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 2043.25 |
|---|---|
| 5-th percentile | 36638.91 |
| Q1 | 266243.72 |
| median | 739383.6 |
| Q3 | 1768543.1 |
| 95-th percentile | 4750751.3 |
| Maximum | 6617209.5 |
| Range | 6615166.3 |
| Interquartile range (IQR) | 1502299.3 |
Descriptive statistics
| Standard deviation | 1491698.5 |
|---|---|
| Coefficient of variation (CV) | 1.1246548 |
| Kurtosis | 1.9586406 |
| Mean | 1326361.3 |
| Median Absolute Deviation (MAD) | 588048.01 |
| Skewness | 1.6097719 |
| Sum | 1.2361687 × 109 |
| Variance | 2.2251644 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90211.77 | 2 | 0.2% |
| 3692591.2 | 1 | 0.1% |
| 3738302.38 | 1 | 0.1% |
| 460786.95 | 1 | 0.1% |
| 852617.04 | 1 | 0.1% |
| 355732.65 | 1 | 0.1% |
| 54421.89 | 1 | 0.1% |
| 3397058.28 | 1 | 0.1% |
| 861563.52 | 1 | 0.1% |
| 1707721.4 | 1 | 0.1% |
| Other values (921) | 921 |
| Value | Count | Frequency (%) |
| 2043.25 | 1 | |
| 2061.93 | 1 | |
| 2556.42 | 1 | |
| 2733.69 | 1 | |
| 3592.05 | 1 | |
| 4114.53 | 1 | |
| 5409.3 | 1 | |
| 7273.97 | 1 | |
| 7501.32 | 1 | |
| 7669.26 | 1 |
| Value | Count | Frequency (%) |
| 6617209.54 | 1 | |
| 6557065.24 | 1 | |
| 6456747.15 | 1 | |
| 6424186.65 | 1 | |
| 6354579.43 | 1 | |
| 6306968.85 | 1 | |
| 6263026.44 | 1 | |
| 6216247.54 | 1 | |
| 6209287.35 | 1 | |
| 6207333.72 | 1 |
TotalCost
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 931 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 937575.8 |
| Minimum | 1416.75 |
|---|---|
| Maximum | 5204978.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 1416.75 |
|---|---|
| 5-th percentile | 23194.373 |
| Q1 | 160430.65 |
| median | 456653.72 |
| Q3 | 1151713 |
| 95-th percentile | 3696940.8 |
| Maximum | 5204978.4 |
| Range | 5203561.7 |
| Interquartile range (IQR) | 991282.37 |
Descriptive statistics
| Standard deviation | 1169022.2 |
|---|---|
| Coefficient of variation (CV) | 1.2468562 |
| Kurtosis | 2.4612689 |
| Mean | 937575.8 |
| Median Absolute Deviation (MAD) | 372660.5 |
| Skewness | 1.7810015 |
| Sum | 8.7382065 × 108 |
| Variance | 1.3666129 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 66909.48 | 2 | 0.2% |
| 2224085.18 | 1 | 0.1% |
| 2811208.76 | 1 | 0.1% |
| 308712.69 | 1 | 0.1% |
| 544494.72 | 1 | 0.1% |
| 238329.63 | 1 | 0.1% |
| 40364.36 | 1 | 0.1% |
| 2936483.88 | 1 | 0.1% |
| 282562.56 | 1 | 0.1% |
| 972247.22 | 1 | 0.1% |
| Other values (921) | 921 |
| Value | Count | Frequency (%) |
| 1416.75 | 1 | |
| 1529.32 | 1 | |
| 1896.08 | 1 | |
| 2027.56 | 1 | |
| 2664.2 | 1 | |
| 3051.72 | 1 | |
| 3624.06 | 1 | |
| 4193.28 | 1 | |
| 5043.63 | 1 | |
| 5232.64 | 1 |
| Value | Count | Frequency (%) |
| 5204978.4 | 1 | |
| 5178730.4 | 1 | |
| 5084237.6 | 1 | |
| 5005493.6 | 1 | |
| 5003918.72 | 1 | |
| 4976151.08 | 1 | |
| 4930922.48 | 1 | |
| 4885277.76 | 1 | |
| 4854305.12 | 1 | |
| 4778652.86 | 1 |
TotalProfit
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 931 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 388785.47 |
| Minimum | 532.61 |
|---|---|
| Maximum | 1726181.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.4 KiB |
Quantile statistics
| Minimum | 532.61 |
|---|---|
| 5-th percentile | 10260.918 |
| Q1 | 94933.545 |
| median | 272935.17 |
| Q3 | 550521.42 |
| 95-th percentile | 1235843.6 |
| Maximum | 1726181.4 |
| Range | 1725648.8 |
| Interquartile range (IQR) | 455587.87 |
Descriptive statistics
| Standard deviation | 381946.21 |
|---|---|
| Coefficient of variation (CV) | 0.98240865 |
| Kurtosis | 1.4517228 |
| Mean | 388785.47 |
| Median Absolute Deviation (MAD) | 207071.82 |
| Skewness | 1.3680055 |
| Sum | 3.6234805 × 108 |
| Variance | 1.458829 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23302.29 | 2 | 0.2% |
| 1468506.02 | 1 | 0.1% |
| 927093.62 | 1 | 0.1% |
| 152074.26 | 1 | 0.1% |
| 308122.32 | 1 | 0.1% |
| 117403.02 | 1 | 0.1% |
| 14057.53 | 1 | 0.1% |
| 460574.4 | 1 | 0.1% |
| 579000.96 | 1 | 0.1% |
| 735474.18 | 1 | 0.1% |
| Other values (921) | 921 |
| Value | Count | Frequency (%) |
| 532.61 | 1 | |
| 626.5 | 1 | |
| 660.34 | 1 | |
| 706.13 | 1 | |
| 927.85 | 1 | |
| 1062.81 | 1 | |
| 1785.24 | 1 | |
| 1937.64 | 1 | |
| 1981.02 | 1 | |
| 2154.49 | 1 |
| Value | Count | Frequency (%) |
| 1726181.36 | 1 | |
| 1725485.88 | 1 | |
| 1697666.68 | 1 | |
| 1682887.73 | 1 | |
| 1641058.46 | 1 | |
| 1631422.21 | 1 | |
| 1626142.76 | 1 | |
| 1587954.71 | 1 | |
| 1575926.57 | 1 | |
| 1571089.32 | 1 |
order_date
Date
| Distinct | 317 |
|---|---|
| Distinct (%) | 34.2% |
| Missing | 4 |
| Missing (%) | 0.4% |
| Memory size | 7.4 KiB |
| Minimum | 2022-01-11 00:00:00 |
|---|---|
| Maximum | 2023-04-30 00:00:00 |
| UnitsSold | ItemType SalesChannel | OrderID | OrderPriority | Revenue | Total | TotalCost | TotalProfit | UnitCost | UnitPrice | |
|---|---|---|---|---|---|---|---|---|---|---|
| UnitsSold | 1.000 | 0.026 | 0.000 | 0.076 | -0.014 | -0.039 | -0.021 | 0.000 | -0.028 | 0.008 |
| ItemType SalesChannel | 0.026 | 1.000 | 0.000 | 0.103 | 0.345 | 0.997 | 0.354 | 0.336 | 0.997 | 0.000 |
| OrderID | 0.000 | 0.000 | 1.000 | 0.029 | 0.000 | 0.000 | 0.027 | 0.007 | 0.034 | 0.066 |
| OrderPriority | 0.076 | 0.103 | 0.029 | 1.000 | 0.040 | 0.071 | 0.058 | 0.059 | 0.080 | 0.056 |
| Revenue | -0.014 | 0.345 | 0.000 | 0.040 | 1.000 | 0.747 | 0.988 | 0.946 | 0.753 | 0.584 |
| Total | -0.039 | 0.997 | 0.000 | 0.071 | 0.747 | 1.000 | 0.783 | 0.610 | 0.972 | 0.015 |
| TotalCost | -0.021 | 0.354 | 0.027 | 0.058 | 0.988 | 0.783 | 1.000 | 0.892 | 0.769 | 0.554 |
| TotalProfit | 0.000 | 0.336 | 0.007 | 0.059 | 0.946 | 0.610 | 0.892 | 1.000 | 0.659 | 0.622 |
| UnitCost | -0.028 | 0.997 | 0.034 | 0.080 | 0.753 | 0.972 | 0.769 | 0.659 | 1.000 | 0.010 |
| UnitPrice | 0.008 | 0.000 | 0.066 | 0.056 | 0.584 | 0.015 | 0.554 | 0.622 | 0.010 | 1.000 |
| Region | Country | ItemType SalesChannel | OrderPriority | OrderID | UnitsSold | UnitPrice | UnitCost | Total | Revenue | TotalCost | TotalProfit | order_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Middle East and North Africa | Libya | Cosmetics | Offline | M | 686800706 | 8446 | 437.20 | 263.33 | 3692591.20 | 2224085.18 | 1468506.02 | 2023-02-13 |
| 1 | North America | Canada | Vegetables | Online | M | 185941302 | 3018 | 154.06 | 90.93 | 464953.08 | 274426.74 | 190526.34 | 2023-03-28 |
| 2 | Middle East and North Africa | Libya | Baby Food | Offline | C | 246222341 | 1517 | 255.28 | 159.42 | 387259.76 | 241840.14 | 145419.62 | 2022-09-08 |
| 3 | Asia | Japan | Cereal | Offline | C | 161442649 | 3322 | 205.70 | 117.11 | 683335.40 | 389039.42 | 294295.98 | 2023-01-07 |
| 4 | Sub-Saharan Africa | Chad | Fruits | Offline | H | 645713555 | 9845 | 9.33 | 6.92 | 91853.85 | 68127.40 | 23726.45 | 2022-04-23 |
| 5 | Europe | Armenia | Cereal | Online | H | 683458888 | 9528 | 205.70 | 117.11 | 1959909.60 | 1115824.08 | 844085.52 | 2022-06-20 |
| 6 | Sub-Saharan Africa | Eritrea | Cereal | Online | H | 679414975 | 2844 | 205.70 | 117.11 | 585010.80 | 333060.84 | 251949.96 | 2022-08-09 |
| 7 | Europe | Montenegro | Clothes | Offline | M | 208630645 | 7299 | 109.28 | 35.84 | 797634.72 | 261596.16 | 536038.56 | 2023-04-06 |
| 8 | Central America and the Caribbean | Jamaica | Vegetables | Online | H | 266467225 | 2428 | 154.06 | 90.93 | 374057.68 | 220778.04 | 153279.64 | 2022-06-05 |
| 9 | Australia and Oceania | Fiji | Vegetables | Offline | H | 118598544 | 4800 | 154.06 | 90.93 | 739488.00 | 436464.00 | 303024.00 | 2023-02-13 |
| Region | Country | ItemType SalesChannel | OrderPriority | OrderID | UnitsSold | UnitPrice | UnitCost | Total | Revenue | TotalCost | TotalProfit | order_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 922 | 9Australia and Oceania | Fiji | Cereal | Online | L | 903278148 | 8932 | 205.70 | 117.11 | 1837312.40 | 1046026.52 | 791285.88 | 2023-02-08 |
| 923 | 0Sub-Saharan Africa | Mali | Beverages | Online | L | 410452497 | 870 | 47.45 | 31.79 | 41281.50 | 27657.30 | 13624.20 | 2023-04-20 |
| 924 | 1Sub-Saharan Africa | Liberia | Cereal | Offline | H | 642683303 | 3126 | 205.70 | 117.11 | 643018.20 | 366085.86 | 276932.34 | 2022-06-07 |
| 925 | 2Europe | Switzerland | Beverages | Offline | L | 682831895 | 3987 | 47.45 | 31.79 | 189183.15 | 126746.73 | 62436.42 | 2022-10-12 |
| 926 | 3Australia and Oceania | Samoa | Baby Food | Online | L | 584072101 | 8769 | 255.28 | 159.42 | 2238550.32 | 1397953.98 | 840596.34 | 2022-05-12 |
| 927 | 4Asia | Nepal | Meat | Offline | C | 919890248 | 4821 | 421.89 | 364.69 | 2033931.69 | 1758170.49 | 275761.20 | 2022-02-21 |
| 928 | 5Middle East and North Africa | Azerbaijan | Snacks | Offline | C | 534085166 | 6524 | 152.58 | 97.44 | 995431.92 | 635698.56 | 359733.36 | 2022-11-06 |
| 929 | 6Europe | Georgia | Baby Food | Offline | H | 590768182 | 288 | 255.28 | 159.42 | 73520.64 | 45912.96 | 27607.68 | 2022-10-07 |
| 930 | 7Middle East and North Africa | United Arab Emirates | Vegetables | Online | C | 524363124 | 9556 | 154.06 | 90.93 | 1472197.36 | 868927.08 | 603270.28 | 2022-08-20 |
| 931 | 9Europe | Portugal | Cereal | Offline | C | 811546599 | 3528 | 205.70 | 117.11 | 725709.60 | 413164.08 | 312545.52 | 2022-06-30 |